SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROC [dbo].[PReqWorkUPDATE]
@Ik_ReqWork INT,
@Years NUMERIC(4,0),
@Period VARCHAR(20),
@Ik_upContent INT
as
SELECT Ik_ReqWork from ReqWork where Ik_ReqWork=@Ik_ReqWork
UPDATE ReqWork
SET
Years=@Years,
Period=@Period,
Ik_upContent=@Ik_upContent
WHERE Ik_ReqWork=@Ik_ReqWork
GO
